CREATE TABLE jms_ods.secondary_abnormal_type_hi
(
    `id`             bigint   COMMENT 'ID',
    `level_one_type` string    COMMENT '一级异常类型: 01网点异常, 02 干线异常',
    `name`           string   COMMENT '异常类型名称',
    `remark`         string   COMMENT '备注',
    `create_by`      int       COMMENT '创建人',
    `create_by_code` string   COMMENT '创建人code',
    `create_by_name` string   COMMENT '创建人name',
    `create_time`    timestamp COMMENT '创建时间',
    `update_by`      int       COMMENT '更新人',
    `update_by_code` string   COMMENT '更新人code',
    `update_by_name` string   COMMENT '更新人name',
    `update_time`    timestamp   COMMENT '更新时间',
    `color_label`    tinyint    COMMENT '颜色标记 1 红色 2 蓝色'
) COMMENT '网点异常类型配置'
partitioned by (dt string comment '分区日期')
stored as parquet
location '/dw/hive/jms_ods.db/external/secondary_abnormal_type_hi'
tblproperties(
'discover.partitions'='false',
'parquet.column.index.access'='true');